inherited fmStokGuncelleme: TfmStokGuncelleme
  Tag = 681
  Left = 247
  Top = 100
  Caption = 'Stok G'#252'ncelle'
  ClientHeight = 514
  ClientWidth = 867
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object GroupBox1: TGroupBox [0]
    Left = 0
    Top = 0
    Width = 867
    Height = 233
    Align = alTop
    Caption = 'Filtre'
    TabOrder = 0
    object lblC1: TLabel
      Left = 9
      Top = 20
      Width = 46
      Height = 13
      Caption = 'Stokkodu'
    end
    object Label18: TLabel
      Left = 9
      Top = 43
      Width = 23
      Height = 14
      Caption = 'Cinsi'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label4: TLabel
      Left = 283
      Top = 22
      Width = 29
      Height = 14
      Caption = 'B'#246'l'#252'm'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label54: TLabel
      Left = 283
      Top = 44
      Width = 43
      Height = 14
      Caption = #220'st Grup'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label49: TLabel
      Left = 283
      Top = 67
      Width = 24
      Height = 14
      Caption = 'Grup'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label3: TLabel
      Left = 521
      Top = 19
      Width = 22
      Height = 14
      Caption = 'Alan'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label5: TLabel
      Left = 521
      Top = 42
      Width = 29
      Height = 14
      Caption = 'De'#287'er'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label1: TLabel
      Left = 9
      Top = 68
      Width = 31
      Height = 14
      Caption = 'Durum'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Bevel1: TBevel
      Left = 5
      Top = 89
      Width = 709
      Height = 5
    end
    object Label2: TLabel
      Left = 9
      Top = 100
      Width = 29
      Height = 14
      Caption = 'Ek Sql'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object edStokKodu: TwwDBComboDlg
      Tag = 1
      Left = 75
      Top = 17
      Width = 160
      Height = 21
      ShowButton = True
      Style = csDropDown
      TabOrder = 2
      WordWrap = False
      UnboundDataType = wwDefault
    end
    object edCinsi: TwwDBComboDlg
      Tag = 1
      Left = 75
      Top = 40
      Width = 160
      Height = 21
      ShowButton = True
      Style = csDropDown
      TabOrder = 3
      WordWrap = False
      UnboundDataType = wwDefault
    end
    object Durum: TwwDBComboBox
      Left = 75
      Top = 63
      Width = 88
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ItemHeight = 0
      Items.Strings = (
        'Aktif'#9'A'
        'Pasif'#9'P')
      ParentFont = False
      Sorted = False
      TabOrder = 4
      UnboundDataType = wwDefault
    end
    object bolumk: TwwDBLookupCombo
      Left = 334
      Top = 17
      Width = 140
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'30'#9'Filitre 1'#9'F')
      LookupTable = St_AnaGrupQ
      LookupField = 'kod'
      Style = csDropDownList
      Navigator = False
      ParentFont = False
      TabOrder = 5
      AutoDropDown = True
      ShowButton = True
      AllowClearKey = True
      ShowMatchText = True
    end
    object CbUstGrup: TwwDBLookupCombo
      Left = 333
      Top = 40
      Width = 140
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9'F'#9)
      LookupTable = dm.aqUstGruphar
      LookupField = 'UstGrupTanimid'
      Style = csDropDownList
      Navigator = False
      ParentFont = False
      TabOrder = 6
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object CbGrup: TwwDBLookupCombo
      Left = 333
      Top = 63
      Width = 140
      Height = 22
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'isim'#9'50'#9'isim'#9'F'#9)
      LookupTable = dm.aqGruphar
      LookupField = 'GrupTanimid'
      Style = csDropDownList
      Navigator = False
      ParentFont = False
      TabOrder = 7
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
      ShowMatchText = True
    end
    object lcAlan: TwwDBLookupCombo
      Left = 559
      Top = 17
      Width = 143
      Height = 21
      DisableThemes = False
      DropDownAlignment = taLeftJustify
      Selected.Strings = (
        'Columnname'#9'30'#9'Columnname'#9'F')
      LookupTable = stStokColumn
      LookupField = 'Columnname'
      Style = csDropDownList
      Navigator = False
      TabOrder = 9
      AutoDropDown = True
      ShowButton = True
      UseTFields = False
      AllowClearKey = True
    end
    object edDeger: TwwDBEdit
      Left = 559
      Top = 40
      Width = 143
      Height = 21
      TabOrder = 10
      UnboundDataType = wwDefault
      WantReturns = False
      WordWrap = False
    end
    object GrdList: TwwDBGrid
      Left = 2
      Top = 158
      Width = 863
      Height = 73
      DisableThemes = False
      ControlType.Strings = (
        'Varyok;CustomEdit;cbSqlDurum;T'
        'Tip;CustomEdit;cbTip;T'
        'SadeceEkSql;CheckBox;True;False')
      Selected.Strings = (
        'Aciklama'#9'36'#9'A'#231#305'klama'#9'F'
        'BasTarihSql'#9'15'#9'Ba'#351'.TarihSql'#9'F'
        'BitTarihSql'#9'15'#9'Bit. TarihSql'#9'F'
        'Tip'#9'25'#9'Tip'
        'Varyok'#9'9'#9'Durumu'#9'F'
        'SadeceEkSql'#9'5'#9'Sadece Ek Sql'#9'F')
      IniAttributes.Delimiter = ';;'
      TitleColor = clBtnFace
      FixedCols = 0
      ShowHorzScrollBar = True
      Align = alBottom
      DataSource = dsEntry
      KeyOptions = [dgEnterToTab, dgAllowInsert]
      Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgWordWrap]
      TabOrder = 0
      TitleAlignment = taLeftJustify
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      TitleLines = 1
      TitleButtons = False
      UseTFields = False
    end
    object EdEkSql: TwwDBEdit
      Left = 47
      Top = 97
      Width = 667
      Height = 54
      AutoSize = False
      MaxLength = 249
      TabOrder = 1
      UnboundDataType = wwDefault
      WantReturns = False
      WordWrap = True
    end
    object Panel2: TPanel
      Left = 724
      Top = 15
      Width = 141
      Height = 143
      Align = alRight
      BevelOuter = bvNone
      TabOrder = 12
      DesignSize = (
        141
        143)
      object btSablonKaydet: TBitBtn
        Left = 53
        Top = 5
        Width = 84
        Height = 29
        Anchors = [akTop, akRight]
        Caption = #350'ablonu Kaydet'
        TabOrder = 0
        TabStop = False
        OnClick = btSablonKaydetClick
      end
      object btSablonSil: TBitBtn
        Left = 53
        Top = 36
        Width = 84
        Height = 29
        Anchors = [akTop, akRight]
        Caption = #350'ablonu Sil'
        TabOrder = 1
        TabStop = False
        OnClick = btSablonSilClick
      end
      object btTemizle: TBitBtn
        Left = 53
        Top = 109
        Width = 84
        Height = 29
        Anchors = [akTop, akRight]
        Caption = 'Temizle'
        TabOrder = 2
        TabStop = False
      end
    end
    object cbTip: TwwDBComboBox
      Left = 385
      Top = 189
      Width = 154
      Height = 21
      ShowButton = True
      Style = csDropDown
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Mal Al'#305'm Faturas'#305#9'1'
        #199#305'k'#305#351' Faturas'#305#9'2'
        #220'retim Emri'#9'3'
        'Stok Hareketi'#9'4'
        'Unityde Olan Stoklar'#9'5')
      Sorted = False
      TabOrder = 8
      UnboundDataType = wwDefault
    end
    object cbSqlDurum: TwwDBComboBox
      Left = 576
      Top = 186
      Width = 58
      Height = 21
      ShowButton = True
      Style = csDropDown
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Var'#9'True'
        'Yok'#9'False')
      Sorted = False
      TabOrder = 11
      UnboundDataType = wwDefault
    end
  end
  object cxgrid1: TcxGrid [1]
    Left = 0
    Top = 233
    Width = 867
    Height = 230
    Align = alClient
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    LookAndFeel.Kind = lfUltraFlat
    LookAndFeel.NativeStyle = True
    object cxgrid1DBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      DataController.DataModeController.GridMode = True
      DataController.DataSource = dsStokListesi
      DataController.Filter.Active = True
      DataController.Filter.AutoDataSetFilter = True
      DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
      DataController.Summary.DefaultGroupSummaryItems = <
        item
          Kind = skCount
          Position = spFooter
        end
        item
          Kind = skCount
        end>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      FilterRow.InfoText = ' '
      FilterRow.Visible = True
      FilterRow.ApplyChanges = fracImmediately
      OptionsBehavior.IncSearch = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsSelection.CellSelect = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.GroupByBox = False
      OptionsView.Indicator = True
      Styles.StyleSheet = dm.tvssDevExpress
      object cxgrid1DBTableView1stokkodu: TcxGridDBColumn
        Caption = 'Stokkodu'
        DataBinding.FieldName = 'stokkodu'
        Width = 129
      end
      object cxgrid1DBTableView1cinsi: TcxGridDBColumn
        Caption = 'Cinsi'
        DataBinding.FieldName = 'cinsi'
        Width = 180
      end
      object cxgrid1DBTableView1aciklama: TcxGridDBColumn
        Caption = 'A'#231#305'klama'
        DataBinding.FieldName = 'aciklama'
        Width = 101
      end
      object cxgrid1DBTableView1OZKOD1: TcxGridDBColumn
        Caption = #214'zelKod1'
        DataBinding.FieldName = 'OZKOD1'
      end
      object cxgrid1DBTableView1OZKOD2: TcxGridDBColumn
        Caption = #214'zelkod2'
        DataBinding.FieldName = 'OZKOD2'
      end
      object cxgrid1DBTableView1YPOzelKod: TcxGridDBColumn
        Caption = 'YP '#214'zelKod'
        DataBinding.FieldName = 'YPOzelKod'
      end
      object cxgrid1DBTableView1izlemeturu: TcxGridDBColumn
        Caption = #304'zleme T'#252'r'#252
        DataBinding.FieldName = 'izlemeturu'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = #304'zleme Yap'#305'lmayacak'
            ImageIndex = 0
            Value = '1'
          end
          item
            Description = 'Seri Numaral'#305' '#304'zleme'
            Value = '2'
          end
          item
            Description = #220'r'#252'n Numaral'#305' '#304'zleme'
            Value = '3'
          end>
      end
      object cxgrid1DBTableView1UstGrupId: TcxGridDBColumn
        Caption = #220'st Grup'
        DataBinding.FieldName = 'UstGrupId'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'id'
        Properties.ListColumns = <
          item
            FieldName = 'isim'
          end>
        Properties.ListSource = dm.dsUstGrup
      end
      object cxgrid1DBTableView1GrupId: TcxGridDBColumn
        Caption = 'Grup'
        DataBinding.FieldName = 'GrupId'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'id'
        Properties.ListColumns = <
          item
            FieldName = 'isim'
          end>
        Properties.ListSource = dm.dsGrup
      end
      object cxgrid1DBTableView1MarkaId: TcxGridDBColumn
        Caption = 'Marka'
        DataBinding.FieldName = 'MarkaId'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'id'
        Properties.ListColumns = <
          item
            FieldName = 'isim'
          end>
        Properties.ListSource = dm.dsMarka
      end
      object cxgrid1DBTableView1ModelId: TcxGridDBColumn
        Caption = 'Model'
        DataBinding.FieldName = 'ModelId'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'id'
        Properties.ListColumns = <
          item
            FieldName = 'isim'
          end>
        Properties.ListSource = dm.dsModel
      end
      object cxgrid1DBTableView1UreticiKodu: TcxGridDBColumn
        Caption = #220'retici Kodu'
        DataBinding.FieldName = 'UreticiKodu'
      end
      object cxgrid1DBTableView1UreticiSatisKodu: TcxGridDBColumn
        Caption = 'Pazarlama Kodu'
        DataBinding.FieldName = 'UreticiSatisKodu'
        Width = 82
      end
      object cxgrid1DBTableView1MuadilKodu: TcxGridDBColumn
        Caption = 'Muadil Kodu'
        DataBinding.FieldName = 'MuadilKodu'
      end
      object cxgrid1DBTableView1Desi: TcxGridDBColumn
        DataBinding.FieldName = 'Desi'
      end
      object cxgrid1DBTableView1Guncel: TcxGridDBColumn
        Caption = 'G'#252'ncel'
        DataBinding.FieldName = 'Guncel'
        PropertiesClassName = 'TcxCheckBoxProperties'
        Properties.NullStyle = nssUnchecked
      end
      object cxgrid1DBTableView1Durum: TcxGridDBColumn
        Caption = 'Durum'
        DataBinding.FieldName = 'Aktif'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = 'Aktif'
            ImageIndex = 0
            Value = 'A'
          end
          item
            Description = 'Pasif'
            Value = 'P'
          end>
      end
    end
    object cxgrid1Level1: TcxGridLevel
      GridView = cxgrid1DBTableView1
    end
  end
  object Panel1: TPanel [2]
    Left = 0
    Top = 463
    Width = 867
    Height = 51
    Align = alBottom
    TabOrder = 2
    DesignSize = (
      867
      51)
    object Panel3: TPanel
      Left = 1
      Top = 1
      Width = 482
      Height = 49
      Align = alLeft
      TabOrder = 0
      object Label6: TLabel
        Left = 15
        Top = 23
        Width = 22
        Height = 14
        Caption = 'Alan'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object Label7: TLabel
        Left = 259
        Top = 23
        Width = 29
        Height = 14
        Caption = 'De'#287'er'
        Font.Charset = TURKISH_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object Label8: TLabel
        Left = 188
        Top = 1
        Width = 122
        Height = 13
        Caption = 'Atanacak De'#287'erleri Giriniz'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clRed
        Font.Height = -11
        Font.Name = 'MS Sans Serif'
        Font.Style = []
        ParentFont = False
      end
      object lcStokAlan: TwwDBLookupCombo
        Left = 45
        Top = 19
        Width = 167
        Height = 21
        DisableThemes = False
        DropDownAlignment = taLeftJustify
        Selected.Strings = (
          'Columnname'#9'30'#9'Columnname'#9'F')
        LookupTable = stStokColumn
        LookupField = 'Columnname'
        Style = csDropDownList
        Navigator = False
        TabOrder = 0
        AutoDropDown = True
        ShowButton = True
        UseTFields = False
        AllowClearKey = True
      end
      object edStokDeger: TwwDBEdit
        Left = 297
        Top = 20
        Width = 167
        Height = 21
        TabOrder = 1
        UnboundDataType = wwDefault
        WantReturns = False
        WordWrap = False
      end
    end
    object btListele: TBitBtn
      Left = 640
      Top = 7
      Width = 100
      Height = 38
      Action = acListele
      Anchors = [akTop, akRight]
      Caption = 'Listele (F5)'
      TabOrder = 1
      TabStop = False
    end
    object btAtamaYap: TBitBtn
      Left = 758
      Top = 7
      Width = 100
      Height = 38
      Anchors = [akTop, akRight]
      Caption = 'Atama Yap'
      TabOrder = 2
      TabStop = False
      OnClick = btAtamaYapClick
    end
  end
  inherited alKeyControl: TActionList
    Left = 694
    Top = 194
    object acListele: TAction
      Caption = 'Listele'
      ShortCut = 116
      OnExecute = acListeleExecute
    end
  end
  inherited XPManifest: TXPManifest
    Left = 1091
    Top = 582
  end
  object aqEntry: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    AfterOpen = aqEntryAfterOpen
    AfterScroll = aqEntryAfterOpen
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'SELECT * FROM TblStokAtama')
    Left = 503
    Top = 275
  end
  object dsEntry: TDataSource
    DataSet = aqEntry
    Left = 544
    Top = 274
  end
  object St_AnaGrupQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from St_AnaGrup')
    Left = 451
    Top = 324
  end
  object stStokColumn: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT [name] AS Columnname'
      'FROM syscolumns'
      'WHERE id = (SELECT id '
      'FROM sysobjects'
      'WHERE type = '#39'U'#39
      'AND [NAME] = '#39'Stok'#39')'
      'order by [name]')
    Left = 533
    Top = 327
  end
  object dsStokListesi: TDataSource
    DataSet = aqStokListesi
    Left = 244
    Top = 333
  end
  object aqStokListesi: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'SELECT * FROM TblStokAtama')
    Left = 203
    Top = 334
  end
end
